| PostalCodeList |
| EntityType | Independent |
| Logical Entity Name | PostalCodeList |
| Default Table Name | syZipCode |
| Logical Only | NO |
| Definition | |
| Note |
| PostalCodeList Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| city | VARCHAR(150) | YES | ||
| state | VARCHAR(4) | YES | ||
| PostalCode | VARCHAR(14) | YES | ||
Id |
INTEGER | NO | ||
| PostalCodeType | CHAR(2) | YES | ||
| Longitude | FLOAT | YES | ||
| Latitude | FLOAT | YES | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| CountyFips | INTEGER | YES | ||
| CountryName | VARCHAR(10) | YES | ||
| CityType | VARCHAR(2) | YES | ||
| ProvinceName | VARCHAR(150) | YES | ||
| StateFIPS | VARCHAR(4) | YES | ||
| CountyName | VARCHAR(150) | YES | ||
| MSACode | VARCHAR(8) | YES | ||
| AreaCode | VARCHAR(50) | YES | ||
| TimeZone | VARCHAR(50) | YES | ||
| UTC | VARCHAR(8) | YES | ||
| DST | BIT | NO | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO |
| PostalCodeList Keys |
| Key Name | Key Type | Keys |
| Nk_SyZipCodeZip | Inversion Entry | PostalCode |
| syZipCode_syZipCodeID_U_C_IDX | PrimaryKey | Id |
| FK_SyZipCodeUserID_SyStaffUserID | Inversion Entry | LastModifiedUserId |
| PostalCodeList Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| PostalCodeList Check Constraints |
| Check Constraint Name | CheckConstraint |